CREATE TABLE [dbo].[FS_Year]
(
[fdYearID] [int] NOT NULL IDENTITY(1, 1),
[fdYearNum] [int] NOT NULL,
[fdYearMonth] [int] NOT NULL,
[fdStuEditStart] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdStuEditStart] DEFAULT (getdate()),
[fdStuEditEnd] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdStuEditEnd] DEFAULT (getdate()),
[fdTeaConStart] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdTeaConStart] DEFAULT (getdate()),
[fdTeaConEnd] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdTeaConEnd] DEFAULT (getdate()),
[fdTeaAddStuStart] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdTeaAddStuStart] DEFAULT (getdate()),
[fdTeaAddStuEnd] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdTeaAddStuEnd] DEFAULT (getdate()),
[fdStatViewStart] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdTeaStatStart] DEFAULT (getdate()),
[fdStatViewEnd] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdTeaStatEnd] DEFAULT (getdate()),
[fdConferStart] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdConferStart] DEFAULT (getdate()),
[fdConferEnd] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdConferEnd] DEFAULT (getdate()),
[fdDelayStart] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdDelayStart] DEFAULT (getdate()),
[fdDelayEnd] [datetime] NOT NULL CONSTRAINT [DF_FS_Year_fdDelayEnd] DEFAULT (getdate()),
[FDCONTRYSTART] [datetime] NULL,
[FDCONTRYEND] [datetime] NULL,
[FDEMPLOYSTART] [datetime] NULL,
[FDEMPLOYEND] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FS_Year] ADD CONSTRAINT [PK_FS_Year] PRIMARY KEY CLUSTERED  ([fdYearID]) ON [PRIMARY]
GO
